package com.erp.erp_entitys.ProductMainInfo;

import java.util.ArrayList;
import java.util.List;

public class ProductMainInfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    private Boolean forUpdate;

    public ProductMainInfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setForUpdate(Boolean forUpdate) {
        this.forUpdate = forUpdate;
    }

    public Boolean getForUpdate() {
        return forUpdate;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCodeIsNull() {
            addCriterion("code is null");
            return (Criteria) this;
        }

        public Criteria andCodeIsNotNull() {
            addCriterion("code is not null");
            return (Criteria) this;
        }

        public Criteria andCodeEqualTo(String value) {
            addCriterion("code =", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotEqualTo(String value) {
            addCriterion("code <>", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThan(String value) {
            addCriterion("code >", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeGreaterThanOrEqualTo(String value) {
            addCriterion("code >=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThan(String value) {
            addCriterion("code <", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLessThanOrEqualTo(String value) {
            addCriterion("code <=", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeLike(String value) {
            addCriterion("code like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotLike(String value) {
            addCriterion("code not like", value, "code");
            return (Criteria) this;
        }

        public Criteria andCodeIn(List<String> values) {
            addCriterion("code in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotIn(List<String> values) {
            addCriterion("code not in", values, "code");
            return (Criteria) this;
        }

        public Criteria andCodeBetween(String value1, String value2) {
            addCriterion("code between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andCodeNotBetween(String value1, String value2) {
            addCriterion("code not between", value1, value2, "code");
            return (Criteria) this;
        }

        public Criteria andChinaNameIsNull() {
            addCriterion("china_name is null");
            return (Criteria) this;
        }

        public Criteria andChinaNameIsNotNull() {
            addCriterion("china_name is not null");
            return (Criteria) this;
        }

        public Criteria andChinaNameEqualTo(String value) {
            addCriterion("china_name =", value, "chinaName");
            return (Criteria) this;
        }

        public Criteria andChinaNameNotEqualTo(String value) {
            addCriterion("china_name <>", value, "chinaName");
            return (Criteria) this;
        }

        public Criteria andChinaNameGreaterThan(String value) {
            addCriterion("china_name >", value, "chinaName");
            return (Criteria) this;
        }

        public Criteria andChinaNameGreaterThanOrEqualTo(String value) {
            addCriterion("china_name >=", value, "chinaName");
            return (Criteria) this;
        }

        public Criteria andChinaNameLessThan(String value) {
            addCriterion("china_name <", value, "chinaName");
            return (Criteria) this;
        }

        public Criteria andChinaNameLessThanOrEqualTo(String value) {
            addCriterion("china_name <=", value, "chinaName");
            return (Criteria) this;
        }

        public Criteria andChinaNameLike(String value) {
            addCriterion("china_name like", value, "chinaName");
            return (Criteria) this;
        }

        public Criteria andChinaNameNotLike(String value) {
            addCriterion("china_name not like", value, "chinaName");
            return (Criteria) this;
        }

        public Criteria andChinaNameIn(List<String> values) {
            addCriterion("china_name in", values, "chinaName");
            return (Criteria) this;
        }

        public Criteria andChinaNameNotIn(List<String> values) {
            addCriterion("china_name not in", values, "chinaName");
            return (Criteria) this;
        }

        public Criteria andChinaNameBetween(String value1, String value2) {
            addCriterion("china_name between", value1, value2, "chinaName");
            return (Criteria) this;
        }

        public Criteria andChinaNameNotBetween(String value1, String value2) {
            addCriterion("china_name not between", value1, value2, "chinaName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameIsNull() {
            addCriterion("english_name is null");
            return (Criteria) this;
        }

        public Criteria andEnglishNameIsNotNull() {
            addCriterion("english_name is not null");
            return (Criteria) this;
        }

        public Criteria andEnglishNameEqualTo(String value) {
            addCriterion("english_name =", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameNotEqualTo(String value) {
            addCriterion("english_name <>", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameGreaterThan(String value) {
            addCriterion("english_name >", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameGreaterThanOrEqualTo(String value) {
            addCriterion("english_name >=", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameLessThan(String value) {
            addCriterion("english_name <", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameLessThanOrEqualTo(String value) {
            addCriterion("english_name <=", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameLike(String value) {
            addCriterion("english_name like", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameNotLike(String value) {
            addCriterion("english_name not like", value, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameIn(List<String> values) {
            addCriterion("english_name in", values, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameNotIn(List<String> values) {
            addCriterion("english_name not in", values, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameBetween(String value1, String value2) {
            addCriterion("english_name between", value1, value2, "englishName");
            return (Criteria) this;
        }

        public Criteria andEnglishNameNotBetween(String value1, String value2) {
            addCriterion("english_name not between", value1, value2, "englishName");
            return (Criteria) this;
        }

        public Criteria andHgCodeIsNull() {
            addCriterion("hg_code is null");
            return (Criteria) this;
        }

        public Criteria andHgCodeIsNotNull() {
            addCriterion("hg_code is not null");
            return (Criteria) this;
        }

        public Criteria andHgCodeEqualTo(String value) {
            addCriterion("hg_code =", value, "hgCode");
            return (Criteria) this;
        }

        public Criteria andHgCodeNotEqualTo(String value) {
            addCriterion("hg_code <>", value, "hgCode");
            return (Criteria) this;
        }

        public Criteria andHgCodeGreaterThan(String value) {
            addCriterion("hg_code >", value, "hgCode");
            return (Criteria) this;
        }

        public Criteria andHgCodeGreaterThanOrEqualTo(String value) {
            addCriterion("hg_code >=", value, "hgCode");
            return (Criteria) this;
        }

        public Criteria andHgCodeLessThan(String value) {
            addCriterion("hg_code <", value, "hgCode");
            return (Criteria) this;
        }

        public Criteria andHgCodeLessThanOrEqualTo(String value) {
            addCriterion("hg_code <=", value, "hgCode");
            return (Criteria) this;
        }

        public Criteria andHgCodeLike(String value) {
            addCriterion("hg_code like", value, "hgCode");
            return (Criteria) this;
        }

        public Criteria andHgCodeNotLike(String value) {
            addCriterion("hg_code not like", value, "hgCode");
            return (Criteria) this;
        }

        public Criteria andHgCodeIn(List<String> values) {
            addCriterion("hg_code in", values, "hgCode");
            return (Criteria) this;
        }

        public Criteria andHgCodeNotIn(List<String> values) {
            addCriterion("hg_code not in", values, "hgCode");
            return (Criteria) this;
        }

        public Criteria andHgCodeBetween(String value1, String value2) {
            addCriterion("hg_code between", value1, value2, "hgCode");
            return (Criteria) this;
        }

        public Criteria andHgCodeNotBetween(String value1, String value2) {
            addCriterion("hg_code not between", value1, value2, "hgCode");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andCataCodeIsNull() {
            addCriterion("cata_code is null");
            return (Criteria) this;
        }

        public Criteria andCataCodeIsNotNull() {
            addCriterion("cata_code is not null");
            return (Criteria) this;
        }

        public Criteria andCataCodeEqualTo(String value) {
            addCriterion("cata_code =", value, "cataCode");
            return (Criteria) this;
        }

        public Criteria andCataCodeNotEqualTo(String value) {
            addCriterion("cata_code <>", value, "cataCode");
            return (Criteria) this;
        }

        public Criteria andCataCodeGreaterThan(String value) {
            addCriterion("cata_code >", value, "cataCode");
            return (Criteria) this;
        }

        public Criteria andCataCodeGreaterThanOrEqualTo(String value) {
            addCriterion("cata_code >=", value, "cataCode");
            return (Criteria) this;
        }

        public Criteria andCataCodeLessThan(String value) {
            addCriterion("cata_code <", value, "cataCode");
            return (Criteria) this;
        }

        public Criteria andCataCodeLessThanOrEqualTo(String value) {
            addCriterion("cata_code <=", value, "cataCode");
            return (Criteria) this;
        }

        public Criteria andCataCodeLike(String value) {
            addCriterion("cata_code like", value, "cataCode");
            return (Criteria) this;
        }

        public Criteria andCataCodeNotLike(String value) {
            addCriterion("cata_code not like", value, "cataCode");
            return (Criteria) this;
        }

        public Criteria andCataCodeIn(List<String> values) {
            addCriterion("cata_code in", values, "cataCode");
            return (Criteria) this;
        }

        public Criteria andCataCodeNotIn(List<String> values) {
            addCriterion("cata_code not in", values, "cataCode");
            return (Criteria) this;
        }

        public Criteria andCataCodeBetween(String value1, String value2) {
            addCriterion("cata_code between", value1, value2, "cataCode");
            return (Criteria) this;
        }

        public Criteria andCataCodeNotBetween(String value1, String value2) {
            addCriterion("cata_code not between", value1, value2, "cataCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeIsNull() {
            addCriterion("customer_code is null");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeIsNotNull() {
            addCriterion("customer_code is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeEqualTo(String value) {
            addCriterion("customer_code =", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeNotEqualTo(String value) {
            addCriterion("customer_code <>", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeGreaterThan(String value) {
            addCriterion("customer_code >", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeGreaterThanOrEqualTo(String value) {
            addCriterion("customer_code >=", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeLessThan(String value) {
            addCriterion("customer_code <", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeLessThanOrEqualTo(String value) {
            addCriterion("customer_code <=", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeLike(String value) {
            addCriterion("customer_code like", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeNotLike(String value) {
            addCriterion("customer_code not like", value, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeIn(List<String> values) {
            addCriterion("customer_code in", values, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeNotIn(List<String> values) {
            addCriterion("customer_code not in", values, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeBetween(String value1, String value2) {
            addCriterion("customer_code between", value1, value2, "customerCode");
            return (Criteria) this;
        }

        public Criteria andCustomerCodeNotBetween(String value1, String value2) {
            addCriterion("customer_code not between", value1, value2, "customerCode");
            return (Criteria) this;
        }

        public Criteria andGecodeIsNull() {
            addCriterion("gecode is null");
            return (Criteria) this;
        }

        public Criteria andGecodeIsNotNull() {
            addCriterion("gecode is not null");
            return (Criteria) this;
        }

        public Criteria andGecodeEqualTo(String value) {
            addCriterion("gecode =", value, "gecode");
            return (Criteria) this;
        }

        public Criteria andGecodeNotEqualTo(String value) {
            addCriterion("gecode <>", value, "gecode");
            return (Criteria) this;
        }

        public Criteria andGecodeGreaterThan(String value) {
            addCriterion("gecode >", value, "gecode");
            return (Criteria) this;
        }

        public Criteria andGecodeGreaterThanOrEqualTo(String value) {
            addCriterion("gecode >=", value, "gecode");
            return (Criteria) this;
        }

        public Criteria andGecodeLessThan(String value) {
            addCriterion("gecode <", value, "gecode");
            return (Criteria) this;
        }

        public Criteria andGecodeLessThanOrEqualTo(String value) {
            addCriterion("gecode <=", value, "gecode");
            return (Criteria) this;
        }

        public Criteria andGecodeLike(String value) {
            addCriterion("gecode like", value, "gecode");
            return (Criteria) this;
        }

        public Criteria andGecodeNotLike(String value) {
            addCriterion("gecode not like", value, "gecode");
            return (Criteria) this;
        }

        public Criteria andGecodeIn(List<String> values) {
            addCriterion("gecode in", values, "gecode");
            return (Criteria) this;
        }

        public Criteria andGecodeNotIn(List<String> values) {
            addCriterion("gecode not in", values, "gecode");
            return (Criteria) this;
        }

        public Criteria andGecodeBetween(String value1, String value2) {
            addCriterion("gecode between", value1, value2, "gecode");
            return (Criteria) this;
        }

        public Criteria andGecodeNotBetween(String value1, String value2) {
            addCriterion("gecode not between", value1, value2, "gecode");
            return (Criteria) this;
        }

        public Criteria andGeIsNull() {
            addCriterion("ge is null");
            return (Criteria) this;
        }

        public Criteria andGeIsNotNull() {
            addCriterion("ge is not null");
            return (Criteria) this;
        }

        public Criteria andGeEqualTo(String value) {
            addCriterion("ge =", value, "ge");
            return (Criteria) this;
        }

        public Criteria andGeNotEqualTo(String value) {
            addCriterion("ge <>", value, "ge");
            return (Criteria) this;
        }

        public Criteria andGeGreaterThan(String value) {
            addCriterion("ge >", value, "ge");
            return (Criteria) this;
        }

        public Criteria andGeGreaterThanOrEqualTo(String value) {
            addCriterion("ge >=", value, "ge");
            return (Criteria) this;
        }

        public Criteria andGeLessThan(String value) {
            addCriterion("ge <", value, "ge");
            return (Criteria) this;
        }

        public Criteria andGeLessThanOrEqualTo(String value) {
            addCriterion("ge <=", value, "ge");
            return (Criteria) this;
        }

        public Criteria andGeLike(String value) {
            addCriterion("ge like", value, "ge");
            return (Criteria) this;
        }

        public Criteria andGeNotLike(String value) {
            addCriterion("ge not like", value, "ge");
            return (Criteria) this;
        }

        public Criteria andGeIn(List<String> values) {
            addCriterion("ge in", values, "ge");
            return (Criteria) this;
        }

        public Criteria andGeNotIn(List<String> values) {
            addCriterion("ge not in", values, "ge");
            return (Criteria) this;
        }

        public Criteria andGeBetween(String value1, String value2) {
            addCriterion("ge between", value1, value2, "ge");
            return (Criteria) this;
        }

        public Criteria andGeNotBetween(String value1, String value2) {
            addCriterion("ge not between", value1, value2, "ge");
            return (Criteria) this;
        }

        public Criteria andBzsmIsNull() {
            addCriterion("bzsm is null");
            return (Criteria) this;
        }

        public Criteria andBzsmIsNotNull() {
            addCriterion("bzsm is not null");
            return (Criteria) this;
        }

        public Criteria andBzsmEqualTo(String value) {
            addCriterion("bzsm =", value, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmNotEqualTo(String value) {
            addCriterion("bzsm <>", value, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmGreaterThan(String value) {
            addCriterion("bzsm >", value, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmGreaterThanOrEqualTo(String value) {
            addCriterion("bzsm >=", value, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmLessThan(String value) {
            addCriterion("bzsm <", value, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmLessThanOrEqualTo(String value) {
            addCriterion("bzsm <=", value, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmLike(String value) {
            addCriterion("bzsm like", value, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmNotLike(String value) {
            addCriterion("bzsm not like", value, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmIn(List<String> values) {
            addCriterion("bzsm in", values, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmNotIn(List<String> values) {
            addCriterion("bzsm not in", values, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmBetween(String value1, String value2) {
            addCriterion("bzsm between", value1, value2, "bzsm");
            return (Criteria) this;
        }

        public Criteria andBzsmNotBetween(String value1, String value2) {
            addCriterion("bzsm not between", value1, value2, "bzsm");
            return (Criteria) this;
        }

        public Criteria andCpjzIsNull() {
            addCriterion("cpjz is null");
            return (Criteria) this;
        }

        public Criteria andCpjzIsNotNull() {
            addCriterion("cpjz is not null");
            return (Criteria) this;
        }

        public Criteria andCpjzEqualTo(String value) {
            addCriterion("cpjz =", value, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzNotEqualTo(String value) {
            addCriterion("cpjz <>", value, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzGreaterThan(String value) {
            addCriterion("cpjz >", value, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzGreaterThanOrEqualTo(String value) {
            addCriterion("cpjz >=", value, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzLessThan(String value) {
            addCriterion("cpjz <", value, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzLessThanOrEqualTo(String value) {
            addCriterion("cpjz <=", value, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzLike(String value) {
            addCriterion("cpjz like", value, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzNotLike(String value) {
            addCriterion("cpjz not like", value, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzIn(List<String> values) {
            addCriterion("cpjz in", values, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzNotIn(List<String> values) {
            addCriterion("cpjz not in", values, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzBetween(String value1, String value2) {
            addCriterion("cpjz between", value1, value2, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpjzNotBetween(String value1, String value2) {
            addCriterion("cpjz not between", value1, value2, "cpjz");
            return (Criteria) this;
        }

        public Criteria andCpmzIsNull() {
            addCriterion("cpmz is null");
            return (Criteria) this;
        }

        public Criteria andCpmzIsNotNull() {
            addCriterion("cpmz is not null");
            return (Criteria) this;
        }

        public Criteria andCpmzEqualTo(String value) {
            addCriterion("cpmz =", value, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzNotEqualTo(String value) {
            addCriterion("cpmz <>", value, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzGreaterThan(String value) {
            addCriterion("cpmz >", value, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzGreaterThanOrEqualTo(String value) {
            addCriterion("cpmz >=", value, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzLessThan(String value) {
            addCriterion("cpmz <", value, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzLessThanOrEqualTo(String value) {
            addCriterion("cpmz <=", value, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzLike(String value) {
            addCriterion("cpmz like", value, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzNotLike(String value) {
            addCriterion("cpmz not like", value, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzIn(List<String> values) {
            addCriterion("cpmz in", values, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzNotIn(List<String> values) {
            addCriterion("cpmz not in", values, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzBetween(String value1, String value2) {
            addCriterion("cpmz between", value1, value2, "cpmz");
            return (Criteria) this;
        }

        public Criteria andCpmzNotBetween(String value1, String value2) {
            addCriterion("cpmz not between", value1, value2, "cpmz");
            return (Criteria) this;
        }
        public Criteria andUpCataCodeIsNull() {
            addCriterion("up_cata_code is null");
            return (Criteria) this;
        }

        public Criteria andUpCataCodeIsNotNull() {
            addCriterion("up_cata_code is not null");
            return (Criteria) this;
        }

        public Criteria andUpCataCodeEqualTo(String value) {
            addCriterion("up_cata_code =", value, "upCataCode");
            return (Criteria) this;
        }

        public Criteria andUpCataCodeNotEqualTo(String value) {
            addCriterion("up_cata_code <>", value, "upCataCode");
            return (Criteria) this;
        }

        public Criteria andUpCataCodeGreaterThan(String value) {
            addCriterion("up_cata_code >", value, "upCataCode");
            return (Criteria) this;
        }

        public Criteria andUpCataCodeGreaterThanOrEqualTo(String value) {
            addCriterion("up_cata_code >=", value, "upCataCode");
            return (Criteria) this;
        }

        public Criteria andUpCataCodeLessThan(String value) {
            addCriterion("up_cata_code <", value, "upCataCode");
            return (Criteria) this;
        }

        public Criteria andUpCataCodeLessThanOrEqualTo(String value) {
            addCriterion("up_cata_code <=", value, "upCataCode");
            return (Criteria) this;
        }

        public Criteria andUpCataCodeLike(String value) {
            addCriterion("up_cata_code like", value, "upCataCode");
            return (Criteria) this;
        }

        public Criteria andUpCataCodeNotLike(String value) {
            addCriterion("up_cata_code not like", value, "upCataCode");
            return (Criteria) this;
        }

        public Criteria andUpCataCodeIn(List<String> values) {
            addCriterion("up_cata_code in", values, "upCataCode");
            return (Criteria) this;
        }

        public Criteria andUpCataCodeNotIn(List<String> values) {
            addCriterion("up_cata_code not in", values, "upCataCode");
            return (Criteria) this;
        }

        public Criteria andUpCataCodeBetween(String value1, String value2) {
            addCriterion("up_cata_code between", value1, value2, "upCataCode");
            return (Criteria) this;
        }

        public Criteria andUpCataCodeNotBetween(String value1, String value2) {
            addCriterion("up_cata_code not between", value1, value2, "upCataCode");
            return (Criteria) this;
        }

        public Criteria andDeactivateTypeEqualTo(Integer value) {
            addCriterion("deactivate_type =", value, "deactivateType");
            return (Criteria) this;
        }

    }

    /**
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}